Value Property (Column Object)

       

Sets or returns the underlying data value in a column for the current row. Not available at design time.

Syntax

object.Value [= value]

The Value property syntax has these parts:

Part Description
object An object expression that evaluates to an object in the Applies To list.
value A string expression that represents the underlying data value in a column for the current row.

Remarks

The Value property is useful for simulating data entry within a cell. When this property is set, the value displayed in the cell respects the setting of the column's NumberFormat property.

This property always returns a string variant, even if the data type of the underlying field is numeric.

Use the Text property to access the formatted data value in a column for the current row.